Create < 3min, Grade Versatility by Instructor Scatter Plot 27

Step 1: Create < 3min, Grade Versatility by Instructor Scatter Plot

- Create 2 new columns, one for instructor first name and one for instructor last name

- Select transform data, right click on column and duplicate column.

- Choose to separate column by delimiter and choose space.

- Rename the first column as First Name and the second Column as Last Name

- Once you have completed the GIF you will hit Close and Apply at the top left hand corner




- Choose a Scatter Plot visual

- Details = First Name, X axis = Graded versatility, Y axis = less than 3 min, Size = Graded Per Day (you will have to change the names of the columns)




- Select formatting under general X position = 218, Y position = 148, Width = 540, Height = 299

- X axis on = start = -0.05 and end = 1.05, color = black, text size = 10, font family = Constantia, title on, title color = black, text size = 10, font family = Constantia

- Y axis on = start = -0.05 and end = 1.02, color = black, text size 10, font famility = Constantia, title on, title color = black, text size = 10, font family = Constantia




- Data colors = Format by field value and based on field Color Measure

- Category on = Color = black, text size = 9, font family = Constantia

- Color border on




- Title is on = < 3min, Grade Versatility by Instructor, font color = black, background color = light blue, alignment = center, text size = 12, font family = Constantia

- Border is on = dark gray



 

-         Choose another Scatter Plot visual, make it larger 

-        Details = First Name, X axis = value from Number Table, Y axis = Value from Number2 table, Size = Graded Per Day (you will have to change the names of the columns).

-        Click on format pane, X axis color = white, Title color = white, Start = 0.05, End 1.05, Y axis color = white, Title color = white 

       -  Format pane, Data color = white background transparency = 100 percent.

       -  Click on Analytics pane, click Add Max Line, Measure = value 1. 

       -  Click another add Max Line, Measure = value 2.

      -  Shape the visual exactly same with other scatter plot Chart, from the selection pane place the second scatter chart behind the first one.



Creating  Shatter plot chart in power bi . 

https://community.powerbi.com/t5/Desktop/Dynamic-Line-and-Scatter-Continuous-axis/td-p/654148 https://www.tutorialgateway.org/scatter-chart-in-power-bi/